IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_MimeTypeAdd]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[cms_sp_MimeTypeAdd]
GO

create procedure [dbo].[cms_sp_MimeTypeAdd]
@Id int = null output,
@MimeTypeName nvarchar(150),
@ContentType nvarchar(250),
@IsImage bit
as

INSERT INTO [dbo].[MimeTypes]
           ([MimeTypeName]
           ,[ContentType]
           ,[IsImage])
     VALUES
           (@MimeTypeName
           ,@ContentType
           ,@IsImage)

set @Id = SCOPE_IDENTITY()

return @Id
GO


